* Rep_Population summary.sps.

* Tables to describe the characteristics of the full quarter per cent sample.
* Written by PSKL on 3/03/03.

GET
  FILE='D:\Longitudinal Data\Rep_Patient Master 1991 to 2001.sav'.

* Summary of patients and number of claims in dataset.

CROSSTABS
  /TABLES=numclam  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 30-MAY-2003 15:44:22
Comments
Input Data D:\Longitudinal Data\Rep_Patient Master 1991 to 2001.sav
File Label Aggregated File
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 80026
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=numclam BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:00.99

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
NUMCLAM * PATSEX 80026 100.0% 0 .0% 80026 100.0%


NUMCLAM * PATSEX Crosstabulation
Count

PATSEX Total
F M
NUMCLAM 1 4876 5160 10036
2 3818 3922 7740
3 3434 3193 6627
4 2990 2775 5765
5 2806 2378 5184
6 2352 2063 4415
7 2080 1860 3940
8 2044 1709 3753
9 1853 1429 3282
10 1746 1338 3084
11 1566 1178 2744
12 1405 1107 2512
13 1274 1006 2280
14 1190 901 2091
15 1094 809 1903
16 1074 824 1898
17 989 701 1690
18 949 694 1643
19 884 581 1465
20 841 610 1451
21 731 553 1284
22 667 447 1114
23 500 345 845
24 378 267 645
25 308 211 519
26 221 203 424
27 192 127 319
28 132 85 217
29 106 68 174
30 94 70 164
31 87 59 146
32 66 31 97
33 56 29 85
34 45 28 73
35 37 26 63
36 27 14 41
37 33 20 53
38 24 12 36
39 22 8 30
40 23 13 36
41 25 4 29
42 7 5 12
43 18 10 28
44 7 5 12
45 8 2 10
46 3 2 5
47 4 2 6
48 4 5 9
49 5
5
50 3 2 5
51 2 1 3
52 1 2 3
53 2 2 4
54 1
1
55 6 1 7
56 2
2
57 1 2 3
58 1
1
59 1 2 3
60
1 1
61 1
1
65
1 1
67 2
2
68
1 1
69 1
1
71
1 1
78 1
1
84 1
1
Total 43121 36905 80026

GET
  FILE='D:\Longitudinal Data\Rep_Teeth Treated 1991 to 2001.sav'.

* Summary of numbers of teeth treatments.

CROSSTABS
  /TABLES=trtcode  BY patsex quadrant tooth
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 30-MAY-2003 15:44:23
Comments
Input Data D:\Longitudinal Data\Rep_Teeth Treated 1991 to 2001.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 905603
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=trtcode BY patsex quadrant tooth
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:23.37

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
TRTCODE * PATSEX 905603 100.0% 0 .0% 905603 100.0%
TRTCODE * QUADRANT 905603 100.0% 0 .0% 905603 100.0%
TRTCODE * TOOTH 905603 100.0% 0 .0% 905603 100.0%


TRTCODE * PATSEX Crosstabulation
Count

PATSEX Total
F M
TRTCODE 701 32 50 82
1101 196 126 322
1102 175 106 281
1111 89 87 176
1112 82 73 155
1131 620 528 1148
1401 38447 36683 75130
1402 8604 8107 16711
1403 73759 69558 143317
1404 31272 28034 59306
1411 157 149 306
1421 66233 61050 127283
1422 7976 7801 15777
1423 1724 1688 3412
1424 606 718 1324
1425 1372 981 2353
1426 32351 30420 62771
1431 15526 16064 31590
1441 4065 1967 6032
1442 886 596 1482
1443 1173 728 1901
1444 2761 1794 4555
1461 243 178 421
1501 17324 15918 33242
1521 320 290 610
1522 93 42 135
1523 11 11 22
1531 1 3 4
1541 302 246 548
1601 1610 758 2368
1701 31 24 55
1702 176 140 316
1703 7 3 10
1704 1059 780 1839
1705 94 69 163
1706 1564 1643 3207
1711 2005 1840 3845
1712 253 214 467
1716 935 459 1394
1721 18931 15499 34430
1722 689 591 1280
1723 69 42 111
1726 21 26 47
1727 12 5 17
1731 2205 2245 4450
1732 1915 1718 3633
1733 1113 1034 2147
1734 5872 4900 10772
1735 2
2
1736 38 47 85
1737 17 23 40
1738 54 19 73
1739 50 24 74
1744 23 28 51
1751 6 16 22
1761 3 2 5
1762 24 24 48
1771 88 87 175
1781 719 599 1318
1782 8876 7598 16474
1801 29 10 39
1802 18 15 33
1803 32 15 47
1804 23 14 37
1805
2 2
1806 2
2
1807 3324 2873 6197
1808 114 103 217
1811 196 252 448
1812 26 32 58
1813 39 59 98
1814 269 201 470
1815 23 21 44
1816 6
6
1821 44 18 62
1822 9 11 20
1823 1 3 4
1824 1
1
1825 2200 1963 4163
1826 77 74 151
1827 3
3
1831 460 476 936
1832 287 268 555
1841 5 1 6
2101 26863 27150 54013
2201 3038 3021 6059
2202 518 704 1222
2203 3384 3700 7084
2204 848 558 1406
2205 521 421 942
2733 43973 41828 85801
2743 3342 3182 6524
2744 3315 2685 6000
2745 2966 3056 6022
2746 138 177 315
2751 25 99 124
2863 4575 4584 9159
3263 1
1
3611 7835 6245 14080
3651 7 1 8
3661 308 245 553
3671 170 250 420
3803 3 2 5
4003 139 47 186
4005 16 13 29
4007 110 131 241
4008 409 344 753
4009 111 100 211
4010 6 1 7
4011 63 59 122
4012 2 5 7
4013 3 1 4
4014 43 45 88
4015 11 9 20
5001 682 602 1284
5021 98 113 211
5031 106 92 198
5032 150 136 286
5041 126 70 196
5071
1 1
5075 16 28 44
5104 2 1 3
5111 19 27 46
5112 359 302 661
5201 378 512 890
5211 26 44 70
5212 1 5 6
5213 42 59 101
5214 10 3 13
5215 2 5 7
5563 15 15 30
5811 31 19 50
5812 17 17 34
5813 105 100 205
5814 52 43 95
5821 134 83 217
5822 47 25 72
5823 8 3 11
5824 7 3 10
5825 10 3 13
5826 128 98 226
5831 53 37 90
5836 7 13 20
5841 21 29 50
5903 28 21 49
5913
5 5
6201 452 386 838
6211 196 158 354
6221 67 106 173
6231 432 330 762
6241 28 58 86
6251 40
40
6263 42 9 51
6264 24 27 51
6265 13 18 31
6273 4 1 5
6274 22 14 36
6275 4 3 7
6283 6 7 13
6284 21 19 40
6285 15 32 47
6301 1041 818 1859
6321 102 77 179
6331 153 100 253
6332 160 141 301
6341 242 206 448
6351 128 131 259
6401 9 8 17
6405 1
1
6501 4 6 10
6511 69 57 126
6512 10 8 18
6513 1 1 2
6521 6 16 22
6522 18 11 29
6523 3
3
6599 14 15 29
Total 470799 434804 905603


TRTCODE * QUADRANT Crosstabulation
Count

QUADRANT Total
LL LR UL UR
TRTCODE 701 19 22 23 18 82
1101

176 146 322
1102 157 124

281
1111

77 99 176
1112 75 80

155
1131 176 193 403 376 1148
1401 19680 19240 18276 17934 75130
1402 4395 4025 4251 4040 16711
1403 34105 33505 38679 37028 143317
1404 11864 11883 18415 17144 59306
1411 65 68 87 86 306
1421 19175 18739 44672 44697 127283
1422 1624 1611 6186 6356 15777
1423 688 631 1069 1024 3412
1424 218 162 469 475 1324
1425 377 380 768 828 2353
1426 15348 14769 16247 16407 62771
1431 7661 7259 8518 8152 31590
1441 1523 1553 1491 1465 6032
1442 396 420 319 347 1482
1443 528 498 470 405 1901
1444 1237 1241 1049 1028 4555
1461 101 126 90 104 421
1501 6345 6332 10513 10052 33242
1521 39 34 261 276 610
1522 8 4 66 57 135
1523

9 13 22
1531 2 1 1
4
1541 32 20 246 250 548
1601

1151 1217 2368
1701 18 13 10 14 55
1702 78 92 71 75 316
1703

8 2 10
1704 491 511 450 387 1839
1705 35 35 49 44 163
1706 991 887 672 657 3207
1711 1144 1139 796 766 3845
1712 133 147 94 93 467
1716 68 80 626 620 1394
1721 4841 4780 12447 12362 34430
1722 133 136 525 486 1280
1723 4 6 55 46 111
1726 5 3 21 18 47
1727 1 3 2 11 17
1731 511 429 1781 1729 4450
1732 415 429 1405 1384 3633
1733 327 313 741 766 2147
1734 2126 2236 3172 3238 10772
1735 1 1

2
1736 24 16 31 14 85
1737 8 9 7 16 40
1738 19 16 21 17 73
1739 22 12 19 21 74
1744 4 7 21 19 51
1751 3 4 6 9 22
1761 1
2 2 5
1762 2 4 28 14 48
1771 28 14 66 67 175
1781 266 192 429 431 1318
1782 1953 1752 6348 6421 16474
1801 4 1 14 20 39
1802 3 9 14 7 33
1803 10 16 8 13 47
1804 5 8 20 4 37
1805

2
2
1806

2
2
1807 596 580 2486 2535 6197
1808 25 16 96 80 217
1811 18 23 214 193 448
1812 4 4 28 22 58
1813 9 10 34 45 98
1814 62 58 164 186 470
1815 6 4 19 15 44
1816
3
3 6
1821 9 14 12 27 62
1822 3 4 9 4 20
1823 2
2
4
1824

1
1
1825 396 408 1685 1674 4163
1826 15 9 67 60 151
1827

1 2 3
1831 137 129 332 338 936
1832 69 78 187 221 555
1841

2 4 6
2101 10742 11040 16438 15793 54013
2201 1216 1208 1818 1817 6059
2202 103 90 525 504 1222
2203 1746 1670 1850 1818 7084
2204 405 372 327 302 1406
2205 418 383 68 73 942
2733 15298 15575 27666 27262 85801
2743 918 969 2294 2343 6524
2744 2205 2154 824 817 6000
2745 506 536 2490 2490 6022
2746 20 25 136 134 315
2751 12 13 50 49 124
2863 1468 1455 3130 3106 9159
3263


1 1
3611 3200 3128 3889 3863 14080
3651 2
5 1 8
3661 113 99 177 164 553
3671 62 59 141 158 420
3803 3 2

5
4003 80 78 13 15 186
4005 8 8 11 2 29
4007 64 74 52 51 241
4008 81 76 285 311 753
4009 18 23 86 84 211
4010 1
4 2 7
4011 8 7 51 56 122
4012

2 5 7
4013 1
3
4
4014 6 4 39 39 88
4015 4 3 9 4 20
5001 324 290 332 338 1284
5021 49 32 60 70 211
5031 37 39 63 59 198
5032 70 60 78 78 286
5041 48 34 60 54 196
5071

1
1
5075 9 9 13 13 44
5104

3
3
5111 4 8 15 19 46
5112 44 56 281 280 661
5201 191 215 241 243 890
5211 14 16 21 19 70
5212 1
1 4 6
5213 28 22 27 24 101
5214 3 3 3 4 13
5215 2 5

7
5563 3 2 11 14 30
5811 12 13 11 14 50
5812 7 12 7 8 34
5813 51 59 48 47 205
5814 26 24 25 20 95
5821 18 20 83 96 217
5822 6 2 27 37 72
5823
1 5 5 11
5824 1 1 4 4 10
5825 1 1 6 5 13
5826 58 48 61 59 226
5831 25 16 26 23 90
5836 11 6 2 1 20
5841 6 13 17 14 50
5903 11 11 14 13 49
5913 2 1 1 1 5
6201 173 174 246 245 838
6211 62 61 114 117 354
6221 37 38 49 49 173
6231 128 130 258 246 762
6241 24 19 25 18 86
6251 8 9 12 11 40
6263 2 1 26 22 51
6264 14 13 11 13 51
6265 5 8 12 6 31
6273

2 3 5
6274 10 11 9 6 36
6275 1 3 2 1 7
6283 5 5 2 1 13
6284 14 13 6 7 40
6285 7 4 18 18 47
6301 467 451 489 452 1859
6321 36 29 67 47 179
6331 48 55 76 74 253
6332 53 71 81 96 301
6341 94 90 135 129 448
6351 55 62 82 60 259
6401

6 11 17
6405


1 1
6501
4 4 2 10
6511 21 22 41 42 126
6512 3 3 7 5 18
6513

1 1 2
6521 6 6 6 4 22
6522 10 5 8 6 29
6523 1 1 1
3
6599 7 2 10 10 29
Total 181924 178920 275020 269739 905603


TRTCODE * TOOTH Crosstabulation
Count

TOOTH Total
1 2 3 4 5 6 7 8
TRTCODE 701




1 2 79 82
1101 61 53 47 39 35 45 36 6 322
1102 33 35 37 29 32 47 49 19 281
1111 32 26 25 22 24 25 18 4 176
1112 25 26 26 23 18 18 15 4 155
1131 163 159 123 144 206 187 143 23 1148
1401 667 700 1484 4388 6286 20316 27941 13348 75130
1402 54 50 436 490 863 6587 6043 2188 16711
1403


19694 29324 44824 39253 10222 143317
1404


8858 15708 20833 12167 1740 59306
1411


38 68 112 61 27 306
1421 33987 29648 30720 14168 8885 6151 3073 651 127283
1422 8025 5068 2684




15777
1423 1837 772 803




3412
1424 746 353 225




1324
1425


817 861 675

2353
1426 5758 5954 10514 10859 8895 10266 8022 2503 62771
1431 1228 1014 941 3343 5344 10862 7477 1381 31590
1441 9 31 9 876 953 1298 1941 915 6032
1442 14 10 6 156 182 391 525 198 1482
1443 3 5 4 225 268 461 627 308 1901
1444 2 11 2 390 572 1295 1663 620 4555
1461 9 12 18 50 75 101 105 51 421
1501 3167 3593 2907 4422 6902 7477 4234 540 33242
1521 277 266 67




610
1522


60 75


135
1523




18 3 1 22
1531




3 1
4
1541 193 180 55 42 56 19 3
548
1601 1327 729 312




2368
1701 3 2 2 2 5 20 17 4 55
1702 2 3 2 34 51 117 88 19 316
1703 4 5 1




10
1704 2 1 1 146 246 877 500 66 1839
1705 3 4 4 18 35 57 38 4 163
1706


90 190 1384 1321 222 3207
1711 8 11 6 39 84 2066 1437 194 3845
1712 5
3 11 10 241 173 24 467
1716 733 515 102 13 27 3 1
1394
1721 7124 6011 3138 5104 7116 4141 1670 126 34430
1722 315 250 119 242 303 34 15 2 1280
1723 51 39 11 6 3 1

111
1726 7 17 9 6 5 1 2
47
1727 4 4
1 4 4

17
1731 1008 1212 640 480 923 125 56 6 4450
1732 646 933 509 509 865 109 54 8 3633
1733 323 362 217 283 487 273 190 12 2147
1734 679 651 438 1603 2365 3071 1763 202 10772
1735



1 1

2
1736 3 2 3 3 5 46 22 1 85
1737
1
5 12 18 4
40
1738 3 6 9 14 10 3 20 8 73
1739 5 3 14 15 13 6 13 5 74
1744 13 18 7 6 7


51
1751 2 6 4
1 4 5
22
1761 1
2
1 1

5
1762 10 11 7 5 9 5 1
48
1771 36 27 41 17 24 18 12
175
1781 205 184 88 113 208 311 189 20 1318
1782 3556 4233 2126 1709 2311 1389 1009 141 16474
1801 7 7 6 3 6 5 5
39
1802 2 1 3 7 7 4 9
33
1803 1
4 6 12 9 12 3 47
1804 3 4 7 2 8 3 8 2 37
1805 1
1




2
1806 1
1




2
1807 1001 819 1512 749 867 606 577 66 6197
1808 37 26 62 22 33 21 15 1 217
1811 102 113 124 32 54 12 10 1 448
1812 16 11 13 3 8 4 3
58
1813 18 18 16 12 18 8 7 1 98
1814 31 35 54 77 97 98 72 6 470
1815 5 1 10 8 12 4 3 1 44
1816

2 1 3


6
1821 3 6 1 15 18 17 2
62
1822 1 3 2 3 2 7 2
20
1823


2
1 1
4
1824 1






1
1825 858 942 272 718 696 610 66 1 4163
1826 35 39 9 30 19 17 2
151
1827
1

1 1

3
1831 304 228 245 55 55 24 23 2 936
1832 236 183 38 50 25 22 1
555
1841 2


2 2

6
2101 5520 5243 3790 5515 6744 7853 9747 9601 54013
2201 251 413 336 575 768 1172 1176 1368 6059
2202 263 465 494




1222
2203


913 1262 2293 1915 701 7084
2204






1406 1406
2205






942 942
2733 12102 11982 6018 12228 14596 16820 11760 295 85801
2743 756 824 455 1066 1163 1347 891 22 6524
2744 445 391 208 756 1201 1780 1193 26 6000
2745 688 761 312 964 1141 1344 785 27 6022
2746 95 110 49 34 11 11 5
315
2751 20 19 14 14 19 19 17 2 124
2863 1854 1911 1897 1431 1028 488 474 76 9159
3263

1




1
3611 2827 1455 1062 1099 1518 2967 2465 687 14080
3651 3

1 2 1 1
8
3661 16 17 16 43 101 223 123 14 553
3671 71 84 142 60 40 14 5 4 420
3803 4
1




5
4003 92 45 19 26 4


186
4005 3 3 1 1 3 6 11 1 29
4007 2 1
1 5 136 79 17 241
4008 176 155 76 147 199


753
4009 34 62 29 33 46 3 3 1 211
4010 2 1 1 1
1 1
7
4011 23 16 35 16 14 10 8
122
4012
1 4
2


7
4013
1 1
1 1

4
4014 17 26 9 17 13 6

88
4015 9 6 2 2
1

20
5001 91 34 46 122 185 444 305 57 1284
5021 23 41 16 25 28 46 26 6 211
5031 26 30 19 30 66 17 9 1 198
5032 2

28 30 137 72 17 286
5041 30 11 14 17 31 48 30 15 196
5071 1






1
5075 4
2 4 7 20 7
44
5104 1 1
1



3
5111 12 7 3 2 3 10 9
46
5112 238 185 85 42 34 42 29 6 661
5201 38 34 23 88 113 205 213 176 890
5211
2 3 6 10 17 22 10 70
5212 2 2 2




6
5213


13 13 35 31 9 101
5214






13 13
5215






7 7
5563 12 7 5 3 2 1

30
5811 1 1 5 3 6 14 15 5 50
5812


1 4 17 9 3 34
5813


24 28 74 60 19 205
5814


15 20 40 19 1 95
5821 92 42 33 20 9 13 7 1 217
5822 48 20 4




72
5823 6 3 2




11
5824 9 1





10
5825


5 3 5

13
5826 17 9 30 28 30 73 35 4 226
5831 12 1 1 11 11 33 18 3 90
5836 3 3 3 1
5 5
20
5841 4 5 6 7 7 10 10 1 50
5903 4 7 4 7 9 12 6
49
5913 2 1

1 1

5
6201 102 99 74 119 134 161 141 8 838
6211 39 40 31 55 57 75 57
354
6221 19 18 13 25 28 36 33 1 173
6231 108 108 56 109 127 145 107 2 762
6241 7 8 1 11 19 24 16
86
6251 3 5 4 4 5 8 11
40
6263 4 3 4 7 10 14 9
51
6264 2 3
4 11 17 14
51
6265 6 6
2 5 7 4 1 31
6273 2
1
2


5
6274 4 5 2 6 6 8 5
36
6275
1 2
1 3

7
6283


2 1 6 4
13
6284
1 1 3 12 15 8
40
6285 5 6 3 6 6 13 8
47
6301 72 60 73 189 324 614 404 123 1859
6321 24 27 14 13 27 46 21 7 179
6331 39 40 29 30 75 21 17 2 253
6332 2 1 1 34 43 128 77 15 301
6341 43 29 23 51 85 127 81 9 448
6351 20 22 14 28 50 84 38 3 259
6401 11 2 4




17
6405



1


1
6501 3 3

1 2 1
10
6511 15 26 10 18 39 8 10
126
6512 5
3 4 5 1

18
6513 1

1



2
6521


1 3 9 7 2 22
6522 1 2

2 16 6 2 29
6523




3

3
6599 2 4 4 7 8 2 2
29
Total 101523 90601 76975 107577 134514 187221 155497 51695 905603

Sort cases by claimIDn.

Aggregate outfile=*
 /presorted
 /break claimIDn
 /patage patsex
 = first (patage patsex).

* Age/Sex for claims containing tooth treatments.

CROSSTABS
  /TABLES=patage  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 30-MAY-2003 15:48:16
Comments
Input File Label Aggregated File
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 344809
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=patage BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:02.46

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
PATAGE * PATSEX 344809 100.0% 0 .0% 344809 100.0%


PATAGE * PATSEX Crosstabulation
Count

PATSEX Total
F M
PATAGE 18 2240 2007 4247
19 2070 1690 3760
20 2149 1808 3957
21 2597 2003 4600
22 2622 1841 4463
23 2895 2084 4979
24 3101 2198 5299
25 3168 2375 5543
26 3554 2629 6183
27 3698 2796 6494
28 3994 2968 6962
29 4303 3137 7440
30 4445 3152 7597
31 4797 3443 8240
32 4446 3174 7620
33 4925 3609 8534
34 4771 3570 8341
35 4433 3418 7851
36 4540 3575 8115
37 4613 3639 8252
38 4214 3414 7628
39 4115 3365 7480
40 3987 3174 7161
41 4023 3036 7059
42 3913 3174 7087
43 4040 3352 7392
44 3936 3444 7380
45 4022 3279 7301
46 3856 3063 6919
47 3729 3135 6864
48 3869 3219 7088
49 3953 3387 7340
50 3673 3206 6879
51 3797 3255 7052
52 3709 3266 6975
53 3482 3132 6614
54 3307 2975 6282
55 3012 2583 5595
56 2826 2599 5425
57 2859 2796 5655
58 2634 2730 5364
59 2402 2506 4908
60 2435 2479 4914
61 2341 2402 4743
62 2037 2220 4257
63 2007 2176 4183
64 1942 2128 4070
65 1944 2086 4030
66 1955 2100 4055
67 1853 2033 3886
68 1726 1711 3437
69 1693 1637 3330
70 1760 1699 3459
71 1537 1438 2975
72 1344 1349 2693
73 1272 1218 2490
74 1240 1152 2392
75 1133 1055 2188
76 1010 914 1924
77 929 775 1704
78 813 677 1490
79 696 580 1276
80 581 498 1079
81 474 362 836
82 449 332 781
83 399 261 660
84 335 206 541
85 216 158 374
86 195 122 317
87 136 90 226
88 110 75 185
89 60 47 107
90 33 34 67
91 37 21 58
92 15 21 36
93 11 3 14
94 9 9 18
95 9 7 16
96 3 5 8
97 1 1 2
98 2
2
99 8 10 18
100 10 9 19
101 6 2 8
102 5 1 6
103 2 3 5
104 1
1
105 1 1 2
107
1 1
108
1 1
Total 187494 157315 344809

GET
  FILE='D:\Longitudinal Data\Rep_Longitudinal Analysis Age group Master 1991 to'+
 ' 2001.sav'.

* Summarise teeth restored by direct restorations.

CROSSTABS
  /TABLES=tooth  BY quadrant
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 30-MAY-2003 15:48:19
Comments
Input Data D:\Longitudinal Data\Rep_Longitudinal Analysis Age group Master 1991 to 2001.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 814701
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=tooth BY quadrant
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:23.01

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Tooth position * Mouth quadrant 814701 100.0% 0 .0% 814701 100.0%


Tooth position * Mouth quadrant Crosstabulation
Count

Mouth quadrant Total
LL LR UL UR
Tooth position 1 6277 6424 27385 27232 67318
2 6875 6503 24432 23715 61525
3 11055 10576 25631 24307 71569
4 20565 20167 28244 29320 98296
5 29159 28835 30372 30663 119029
6 44104 44313 47109 45814 181340
7 41777 40644 41190 39012 162623
8 14918 13768 12579 11736 53001
Total 174730 171230 236942 231799 814701

CROSSTABS
  /TABLES=patagegr  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 30-MAY-2003 15:48:42
Comments
Input Data D:\Longitudinal Data\Rep_Longitudinal Analysis Age group Master 1991 to 2001.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 814701
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=patagegr BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:22.83

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Patient age (years) * patient sex 814701 100.0% 0 .0% 814701 100.0%


Patient age (years) * patient sex Crosstabulation
Count

patient sex Total
F M
Patient age (years) 18 or 19 12865 12976 25841
20 to 29 94284 83663 177947
30 to 39 109296 94549 203845
40 to 49 82147 75649 157796
50 to 59 61389 60068 121457
60 to 69 35713 40837 76550
70 to 79 20618 20566 41184
80 or older 5636 4445 10081
Total 421948 392753 814701

CROSSTABS
  /TABLES=maintrt  BY patagegr  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 30-MAY-2003 15:49:05
Comments
Input Data D:\Longitudinal Data\Rep_Longitudinal Analysis Age group Master 1991 to 2001.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 814701
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=maintrt BY patagegr BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 3
Cells Available 95325
Elapsed Time 0:00:22.72

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Main Treatment * Patient age (years) * patient sex 814701 100.0% 0 .0% 814701 100.0%


Main Treatment * Patient age (years) * patient sex Crosstabulation
Count

Patient age (years) Total
patient sex 18 or 19 20 to 29 30 to 39 40 to 49 50 to 59 60 to 69 70 to 79 80 or older
F Main Treatment Single surface amalgam 4732 24603 17101 8878 5724 3262 1825 550 66675
Two surface amalgam, not MO or DO 630 4058 3709 2603 1710 890 501 144 14245
MO or DO amalgam 3846 32584 37761 24313 14516 6920 2942 633 123515
MOD amalgam 767 8736 15340 12710 8358 3498 1389 248 51046
Tunnel amalgam 18 116 75 32 11 6 7
265
Composite resin 2016 16458 22833 21552 20126 13126 8652 2319 107082
Glass ionomer 658 5662 9699 9918 9339 7340 4942 1656 49214
Root filling 198 2067 2778 2141 1605 671 360 86 9906
Total 12865 94284 109296 82147 61389 35713 20618 5636 421948
M Main Treatment Single surface amalgam 4320 22441 15707 8813 5871 3913 1981 436 63482
Two surface amalgam, not MO or DO 588 3634 3361 2426 1759 1014 488 85 13355
MO or DO amalgam 3940 28651 32975 23335 15068 8320 3274 578 116141
MOD amalgam 866 7815 12622 11203 7795 3756 1318 203 45578
Tunnel amalgam 28 97 61 33 16 1 2 2 240
Composite resin 2254 14315 19659 18632 18565 14582 8219 1660 97886
Glass ionomer 706 4717 7593 9193 9468 8328 4903 1395 46303
Root filling 274 1993 2571 2014 1526 923 381 86 9768
Total 12976 83663 94549 75649 60068 40837 20566 4445 392753

* Reduce to claims.

Sort cases by claimIDn.

Aggregate outfile=*
 /presorted
 /break claimIDn
 /patagegr patsex patidn
 = first (patagegr patsex patidn).

CROSSTABS
  /TABLES=patagegr  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 30-MAY-2003 15:54:21
Comments
Input File Label Aggregated File
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 261227
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=patagegr BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:02.10

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Patient age (years) * patient sex 261227 100.0% 0 .0% 261227 100.0%


Patient age (years) * patient sex Crosstabulation
Count

patient sex Total
F M
Patient age (years) 18 or 19 3406 3036 6442
20 to 29 25329 19217 44546
30 to 39 35287 27444 62731
40 to 49 29741 24947 54688
50 to 59 23002 21111 44113
60 to 69 14111 15122 29233
70 to 79 8169 7639 15808
80 or older 2085 1581 3666
Total 141130 120097 261227

* Reduce to patients, and number of filling claims.

Sort cases by patidn.

Aggregate outfile=*
 /presorted
 /break patidn
 /patsex = first(patsex)
 /nclaims=n.

CROSSTABS
  /TABLES=nclaims  BY patsex
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT .

Crosstabs

Notes
Output Created 30-MAY-2003 15:54:33
Comments
Input File Label Aggregated File
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 77992
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax CROSSTABS
/TABLES=nclaims BY patsex
/FORMAT= AVALUE TABLES
/CELLS= COUNT .
Resources Dimensions Requested 2
Cells Available 116508
Elapsed Time 0:00:00.50

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
NCLAIMS * patient sex 77992 100.0% 0 .0% 77992 100.0%


NCLAIMS * patient sex Crosstabulation
Count

patient sex Total
F M
NCLAIMS 1 14366 12873 27239
2 7961 6770 14731
3 5358 4657 10015
4 3879 3149 7028
5 2781 2287 5068
6 2075 1688 3763
7 1546 1189 2735
8 1038 874 1912
9 816 706 1522
10 574 528 1102
11 454 357 811
12 316 262 578
13 230 173 403
14 144 149 293
15 119 99 218
16 80 88 168
17 52 60 112
18 37 41 78
19 26 32 58
20 12 22 34
21 22 12 34
22 7 10 17
23 4 7 11
24 6 4 10
25 2 8 10
26 5 7 12
27 3 4 7
28 2 1 3
29 4 1 5
30 4 2 6
31 1 2 3
32 1
1
33
1 1
34
1 1
35
1 1
37 1
1
41 1
1
Total 41927 36065 77992